-- Create the source table
CREATE TABLE OldCustomerDemographics
(
	CustomerID INT IDENTITY(1,1)
	, CustFirstName VARCHAR(50) NOT NULL
	, CustLastName VARCHAR(50) NOT NULL
	, CustSalesRegion VARCHAR(20) NULL
	, CustStatus VARCHAR(20) NOT NULL
)

-- Create the destination table
CREATE TABLE NewCustomerDemographics
(
	CustomerID INT
	, CustFirstName VARCHAR(50) NOT NULL
	, CustLastName VARCHAR(50) NOT NULL
	, CustSalesRegion VARCHAR(20) NULL
	, CustStatus VARCHAR(20) NOT NULL
)

-- Populate the source table
INSERT OldCustomerDemographics VALUES ('Jim', 'Halpert', 'SOUTHWEST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Michael', 'Scott', 'NORTHEAST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Dwight', 'Schrute', 'WEST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Jan', 'Levinson', NULL, 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Pam', 'Beesly', 'EAST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Andy', 'Bernard', 'CENTRAL', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Angela', 'Martin', 'SOUTHEAST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Toby', 'Flenderson', 'MIDWEST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Ryan', 'Howard', NULL, 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Creed', 'Bratton', 'SOUTHWEST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Kevin', 'Malone', 'NORTHEAST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Phyllis', 'Lapin', 'WEST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Darryl', 'Philbin', 'EAST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Oscar', 'Martinez', 'CENTRAL', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Kelly', 'Kapoor', 'SOUTHEAST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Meredith', 'Palmer', 'MIDWEST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Stanley', 'Hudson', 'NORTH', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Karen', 'Filippelli', 'NORTH', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Bob', 'Vance', NULL, 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('David', 'Wallace', 'NONE', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Josh', 'Porter', 'CENTER', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Holly', 'Flax', 'SOUTHWEST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Todd', 'Packer', 'NORTHEAST', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Carol', 'Stills', 'CENTRAL', 'ACTIVE')
INSERT OldCustomerDemographics VALUES ('Jim', 'Halpert', 'SOUTHWEST', 'ACTIVE')
